IF EXISTS (SELECT name FROM sys.all_objects WHERE name='Yom_Admin')
DROP TABLE [Yom_Admin]

GO

IF EXISTS (SELECT name FROM sys.all_objects WHERE name='Yom_Category')
DROP TABLE [Yom_Category]

GO

IF EXISTS (SELECT name FROM sys.all_objects WHERE name='Yom_Chapter')
DROP TABLE [Yom_Chapter]

GO

IF EXISTS (SELECT name FROM sys.all_objects WHERE name='Yom_Comic')
DROP TABLE [Yom_Comic]

GO

IF EXISTS (SELECT name FROM sys.all_objects WHERE name='Yom_Link')
DROP TABLE [Yom_Link]

GO

IF EXISTS (SELECT name FROM sys.all_objects WHERE name='Yom_Note')
DROP TABLE [Yom_Note]

GO

IF EXISTS (SELECT name FROM sys.all_objects WHERE name='Yom_Setting')
DROP TABLE [Yom_Setting]

GO

IF EXISTS (SELECT name FROM sys.all_objects WHERE name='Yom_Volume')
DROP TABLE [Yom_Volume]

GO